USING T-SQL TO SCRIPT SSIS PACKAGE

Last Post 27 Mar 2008 09:57 AM by ckim472. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ckim472
New Member
New Member

--
25 Mar 2008 08:09 AM
Is it possible to run a SSIS job from query analyzer by scripting it with T-SQL?

Thanks!
ckim472
ckim472
New Member
New Member

--
25 Mar 2008 01:09 PM
Just a generic data transfer of a excel file with about 2500 records. Nothing fancy, just wondering if it's
possible to have a script rather than going through the SSIS import wizard.

ckim472
SQLUSA
New Member
New Member

--
25 Mar 2008 05:18 PM
Query Analyzer is SQL Server 2000 terminology.

Query Editor in SQL Server 2005 and SQL Server 2008.

You can run DTEXEC using xp_cmdshell

Kalman Toth
SQL Server Training

ckim472
New Member
New Member

--
27 Mar 2008 09:57 AM
tHANKS!!
You are not authorized to post a reply.

Acceptable Use Policy