Sladescross's Blog

Blogging about Sharepoint related stuff

SSIS Container Hierarchy April 17, 2014

Filed under: Container,Container Hierarchy,Hierarchy,SSIS — sladescross @ 1:33 pm

http://consultingblogs.emc.com/jamiethomson/archive/2004/12/13/445.aspx

 

OnPipelineRowsSent April 15, 2014

Filed under: Pipeline,Rows,SSIS — sladescross @ 4:29 pm

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/08/SSIS_3A00_-OnPipelineRowsSent.aspx

 

Uploading to SQL Azure Using SSIS February 26, 2014

Filed under: SQL Azure,SSIS,Uploading — sladescross @ 4:25 pm

http://www.databasejournal.com/features/mssql/windows-azure-sql-database-uploading-data-by-using-sql-server-integration-services.html

 

Upgrade SSIS 2008 Packages

Filed under: Package,SSIS,Upgrade — sladescross @ 3:50 pm

http://sqldusty.wordpress.com/2012/03/19/upgrade-2008-ssis-packages-to-2012-like-a-boss/

 

DTExec February 24, 2014

Filed under: DTEXEC,PATH,SSIS — sladescross @ 1:40 pm

http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

On a 64-bit computer, Integration Services installs a 64-bit version of the dtexec utility (dtexec.exe). If you have to run certain packages in 32-bit mode, you will have to install the 32-bit version of the dtexec utility. To install the 32-bit version of the dtexec utility, you must select either Client Tools or Business Intelligence Development Studio during setup.

By default, a 64-bit computer that has both the 64-bit and 32-bit versions of an Integration Services command prompt utility installed will run the 32-bit version at the command prompt. The 32-bit version runs because the directory path for the 32-bit version appears in the PATH environment variable before the directory path for the 64-bit version. (Typically, the 32-bit directory path is :\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn, while the 64-bit directory path is :\Program Files\Microsoft SQL Server\100\DTS\Binn.)

 

SSIS and ODBC Driver and Bitness

Filed under: 32bit,64bit,Bitness,DTEXEC,Integration,ODBC,SQL Agent,SSIS — sladescross @ 1:11 pm

http://sqlblog.com/blogs/jamie_thomson/archive/2012/03/08/odbc-in-ssis-2012.aspx

Can’t populate an Object variable with a recordset when using an Execute SQL Task connecting to an ODBC data source;

http://microsoft-ssis.blogspot.co.uk/2012/09/swtich-package-from-64bit-to-32bit.html

If you have a 64bit machine, with connections that only support 32bit (like Excel, Access and old ODBC connections) you will get an error like above. The solution is to run your package in 32bit mode. This can be done within Visual Studio for debugging or within SQL Server Management Studio for scheduled packages.

SSDT

Right Click the SSIS project and select Properties in the context menu. Go to the Debugging pane and select false under Run64bitRuntime.

SQL Server Management Studio
Edit your job and then edit the right jobstep. Go to the Execution Options pane and check “Use 32 bit runtime”. This property will only effect the package (+child packages) called in this jobstep.

Note: For 32bit execution via dtexec.exe you need to pick the right folder:
32bit => C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe
64bit => C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe

http://stackoverflow.com/questions/13943765/why-does-my-odbc-connection-fail-when-running-an-ssis-load-in-visual-studio-but

Fixing SQL Agent

You will need to edit the existing SQL Agent job to change the bittedness of the job step. This will be under the Configuration tab and then under the Advanced tab. Check/Uncheck the 32-bit runtime.

http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/16/32-bit-odbc-on-windows-server-2008-r2.aspx

:\Windows\SysWOW64\odbcad32.exe

If you double-click a dtsx file from Windows Explorer, it is executed by the SQL Server 2008 Integration Services Package Execution Utility. The default fully qualified path for that tool is C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\DTExecUI.exe. In other words, it is a 32-bit product, so it doesn’t have any trouble running things in 32-bit mode by definition.

 

SSIS and REST and Script Task February 5, 2014

Filed under: Code,REST,Script Task,SSIS — sladescross @ 3:29 pm

http://markarlenplace.wordpress.com/2010/12/30/consuming-restful-web-services-in-an-ssis-script-transformation/

 

Applied Business Intelligence : SSIS Design Pattern – Incremental Loads January 29, 2014

Filed under: Design Pattern,Incremental Load,SSIS — sladescross @ 12:29 pm
Tags:

http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx

 

SSIS Logging and Data Auditing | Business Intelligence content from SQL Server Pro January 25, 2014

Filed under: Auditing,Data Auditing,Logging,SSIS — sladescross @ 10:37 am

http://sqlmag.com/business-intelligence/ssis-logging-and-data-auditing

 

SSIS Logging Best Practices | SQL Server Integration Services content from SQL Server Pro

Filed under: Best Practice,Example,Logging,SSIS — sladescross @ 10:26 am

http://m.sqlmag.com/sql-server-integration-services/ssis-logging-best-practices

 

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers