Script(s)

technology as-is

March 12, 2013
by gchandra
0 comments

Save and Schedule SSIS Packages using SQL Server 2008 R2 for Nonadmins

How to Save and Schedule SSIS Packages using SQL Server 2008 R2 for Non Administrators Step 1 Upgrade SQLServer 2008 R2 with latest SP Step 2 Saving Package from Business Intelligence (.dtsx) to SQL Server EXEC sp_addrolemember 'db_ssisltduser', '<<user/group>>' EXEC … Continue reading

October 7, 2010
by gchandra
0 comments

SSIS import mixed datatypes from Excel to SQLServer

While importing data from Excel to SQLServer, if a Excel column in has both Text and Numeric values then either Text or Numeric values will be NULL in SQLServer. See example.. If first data cell (in Excel) in that particular … Continue reading

May 6, 2010
by gchandra
0 comments

Rearrange SSIS Packages in SSIS Project.

If you create multiple packages in a Project, SQLServer Business Intelligence will not sort them based on file name.  There is an alternate way to sort the items in the way you need. Open .dtproj file in Notepad / Notepad … Continue reading