Converting DTS to SSIS

Question

Post reply

Converting DTS to SSIS

sachinbb

SSChasing Mays

Points: 602
More actions
December 10, 2008 at 9:11 am

#128351

Hi All,
I have a job scheduled to run dts package through a command file. The cmd file has DTSRUN command like:
DTSRUN /A gvSrceFile:8="%BUDGET_XLS%" /A gvDestSrvr:8=%SQLSrvr% /A gvDestDb:8=%DBName% /A gvDestTbl:8=%DBTable% /A gvExceptionFileRoot:8=%LogDir% /A gvBatchName:8=%ETLName% /F%DTSPackage% >> %RestartLog%
the environment is
DBMS: SQL Server 2005
Server: Windows Server 2003
I am converting my DTS packages to SSIS which are working if run by themselves.
Now I am trying to have the cmd file call the SSIS packages similar to the above statement for DTS package calls. I have tried different syntax i.e. quoatations, none quoatation etc… but nothing seems to be working for me. Look below at an example.
: DTEXEC /f %DTSPackage% /set \Package.Variables[User::gvSrceFile].Properties[Value]; %BUDGET_XLS% /set \Package.Variables[User::gvDestSrvr].Properties[Value] ; %SQLSrvr% /set \Package.Variables[User::DBName].Properties[Value] ; %DBName% /set \Package.Variables[User::gvDestTbl].Properties[Value] ; %DBTable% /set \Package.Variables[User::gvExceptionFileRoot].Properties[Value] ; %LogDir% /set \Package.Variables[User::gvBatchName].Properties[Value] ; %ETLName% /F %DTSPackage% >> %RestartLog%
I am getting this error
Argument ""\Package.Variables[User::gvSrceFile].Properties[Value];"" for option "set" is not valid.
Please give me some idea as to why I am getting this error.
Thanks in advance!
S

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736607 More actions · Answer 1

Why not schedule the package and then take that command line?

Does this help?

http://msdn.microsoft.com/en-us/library/ms345282.aspx

sachinbb SSChasing Mays Points: 602 More actions · Answer 2

The scheduled job runs multiple DTS packages and runs daily (creates logs, error logs etc). It is also has the multiple variables going to the DTS package dynamically.

For example depending on the location of the store the values of the variables will change.

thnx

sachinbb SSChasing Mays Points: 602 More actions · Answer 3

Any help on this is much appreciated since i m still trying to figure out where my DTEXEC cmd is not correct.

sachinbb SSChasing Mays Points: 602 More actions · Answer 4

Hi All,

I finally got the proper syntax for the DTEXEC 32 bit running. Now i m facing a incompatible version issue.

I am running SSIS Packages on a Windows Server 2003 and my DTEXEC command is runnibg as Version 9.00.1399.06 for 32-bit.

Has any one seen this error?

The task "Set Global Variables" cannot run on this edition of Integration Services. It requires a higher level edition.

Thanks in advance

S

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

sachinbb (12/24/2008)
Hi All,
I finally got the proper syntax for the DTEXEC 32 bit running. Now i m facing a incompatible version issue.
I am running SSIS Packages on a Windows Server 2003 and my DTEXEC command is runnibg as Version 9.00.1399.06 for 32-bit.
Has any one seen this error?
The task "Set Global Variables" cannot run on this edition of Integration Services. It requires a higher level edition.
Thanks in advance
S

If you already asked your question in a separate thread, do not double-post in non-related threads. It is harder for other people to follow the discussion.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

sachinbb SSChasing Mays Points: 602 More actions · Answer 6

OK,

My thread is now moved to :

http://www.sqlservercentral.com/Forums/Topic625533-148-1.aspx#bm625542

thnx