Tag Archives: SSIS

Converting from Teradata Timestamp to SQL Server Datetime ‏

Teradata has a timestamp data type that appears to be equivalent to a SQL Server datetime.  It is not. Attempting to use the SSIS Data Conversion task will likely fail with a truncation error.  While the solution below is extremely … Continue reading

Posted in SQL Server Integration Services, Teradata | Tagged , , , , | Leave a comment

Loading XML data from a URL in SSIS

Loading XML data from a web endpoint in SSIS is easier than it seems.  Create a Data Flow Task and add a XML Source Task.  While it appears the task is looking for an XML file path, a URL can … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 3 Comments

How I fixed – JobOwner doesn’t have permissions to use proxy 1 for subsystem PowerShell

I encountered this pesky error when trying get a PowerShell script to run from SSIS.  It ran fine from PS.  I had defined a credential and a proxy so I thought I had the security settings correct.  Here is how … Continue reading

Posted in PowerShell, SQL Server Integration Services | Tagged , , , , | Leave a comment

SSIS Select Distinct From Excel Data Source

I had to modify an existing SSIS package and found that the author had an Excel data source with duplicate rows in it. The destination needed unique records. The author’s solution was to save the data to a staging table … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 1 Comment

The Excel Connection Manager is not supported in the 64-bit version of SSIS

As most new PCs are shipping with a 64-bit OS this is becoming a more common error.  I always forget how to resolve this and have to look it up so I thought if I wrote about it in a … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 54 Comments