My Requirement :
--Transffer data from XL to SQL.
-- Want to change connection of xl file dynamically with different name
Trying :
-- I have created one xl conn, one sql connection in DTS.
-- Created one global variable "Source File" as string data type
-- Gave some file path value to global variable
-- Now i changed Data source of Xl to global variable
-- So the sequence is first dynamic property task will run and then data transfer between file and sql.
-- Now if i run this dts from another dts passing different value of file name using inner package global variable then it runs fine.
Perfect. But still this is a manual operation to change file name in Inner package variable.
-- so i was trying to run DTS from query analzer using xp_cmdshell and want to pass global variable....
but getting error.
i am running
---exec xp_cmdshell "DTSRun /S UWSTAGE /U test /P test897 /N test_U_list /A SourceFile: 8 = C:\test\5240-Silvercrest Extended Care Facility-.xls"
its giving me this kind of error sequence ''''''''''''''
==========================================
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54)
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436
===========================================
Thanks in Advance.
Brijesh Shah
rgds,
Brijesh Shah
Database Specialist
@IS-SEIU1199
@212-603-1759
--Transffer data from XL to SQL.
-- Want to change connection of xl file dynamically with different name
Trying :
-- I have created one xl conn, one sql connection in DTS.
-- Created one global variable "Source File" as string data type
-- Gave some file path value to global variable
-- Now i changed Data source of Xl to global variable
-- So the sequence is first dynamic property task will run and then data transfer between file and sql.
-- Now if i run this dts from another dts passing different value of file name using inner package global variable then it runs fine.
Perfect. But still this is a manual operation to change file name in Inner package variable.
-- so i was trying to run DTS from query analzer using xp_cmdshell and want to pass global variable....
but getting error.
i am running
---exec xp_cmdshell "DTSRun /S UWSTAGE /U test /P test897 /N test_U_list /A SourceFile: 8 = C:\test\5240-Silvercrest Extended Care Facility-.xls"
its giving me this kind of error sequence ''''''''''''''
==========================================
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54)
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436
===========================================
Thanks in Advance.
Brijesh Shah
rgds,
Brijesh Shah
Database Specialist
@IS-SEIU1199
@212-603-1759