sql server dts:
And what does this step contain?
'DTSStep_DTSExecuteSQLTask_1'
I know it is an ExecuteSQL task but to what Server/DB does it point and
what Statement does it execute. If you investigate these three things
you will find your answer.
Allan
[quoted text, click to view] "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
> I have been given the Administrator Role (in our server).In our server there
> are two databases.I'm in Public role for both databses .My DTS package works
> in one database in other database it gives me this error :
>
> Step 'DTSStep_DTSDataPumpTask_1' failed
> Step Error Source: Microsoft OLE DB Provider for SQL Server
> Step Error Description:Syntax error or access violation
> Step Error code: 80074005
> Step Error Help File:
> Step Error Help Context ID:0
> Step Execution Started: 5/30/2005 11:40:46 AM
> Step Execution Completed: 5/30/2005 11:40:46 AM
> Total Step Execution Time: 0.157 seconds
> Progress count in Step: 0
> Step 'DTSStep_DTSExecuteSQLTask_1' was not executed
I have been given the Administrator Role (in our server).In our server there
are two databases.I'm in Public role for both databses .My DTS package works
in one database in other database it gives me this error :
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Syntax error or access violation
Step Error code: 80074005
Step Error Help File:
Step Error Help Context ID:0
Step Execution Started: 5/30/2005 11:40:46 AM
Step Execution Completed: 5/30/2005 11:40:46 AM
Total Step Execution Time: 0.157 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask_1' was not executed
'DTSStep_DTSExecuteSQLTask_1' is pumping data from a CSV file into the Table
in database.
it works with one of the databases and dosen't work for the other
database.The databases seem to be completely identical(I'm not sure though).
Thanks
[quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23Exv7hUZFHA.3104@TK2MSFTNGP10.phx.gbl...
> And what does this step contain?
>
> 'DTSStep_DTSExecuteSQLTask_1'
>
> I know it is an ExecuteSQL task but to what Server/DB does it point and
> what Statement does it execute. If you investigate these three things you
> will find your answer.
>
> Allan
>
> "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
>
>> I have been given the Administrator Role (in our server).In our server
>> there
>> are two databases.I'm in Public role for both databses .My DTS package
>> works
>> in one database in other database it gives me this error :
>>
>> Step 'DTSStep_DTSDataPumpTask_1' failed
>> Step Error Source: Microsoft OLE DB Provider for SQL Server
>> Step Error Description:Syntax error or access violation
>> Step Error code: 80074005
>> Step Error Help File:
>> Step Error Help Context ID:0
>> Step Execution Started: 5/30/2005 11:40:46 AM
>> Step Execution Completed: 5/30/2005 11:40:46 AM
>> Total Step Execution Time: 0.157 seconds
>> Progress count in Step: 0
>> Step 'DTSStep_DTSExecuteSQLTask_1' was not executed
>
Allen ,I think I got the answer with your hint.
I'm using a dynamic property to change the connections in the dts based on a
global variable.Apparetly that property is not setting the new database
catalog name .
Thanks for your help
[quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23Exv7hUZFHA.3104@TK2MSFTNGP10.phx.gbl...
> And what does this step contain?
>
> 'DTSStep_DTSExecuteSQLTask_1'
>
> I know it is an ExecuteSQL task but to what Server/DB does it point and
> what Statement does it execute. If you investigate these three things you
> will find your answer.
>
> Allan
>
> "J-T" <J-T@microsft.com> wrote in message news:J-T@microsft.com:
>
>> I have been given the Administrator Role (in our server).In our server
>> there
>> are two databases.I'm in Public role for both databses .My DTS package
>> works
>> in one database in other database it gives me this error :
>>
>> Step 'DTSStep_DTSDataPumpTask_1' failed
>> Step Error Source: Microsoft OLE DB Provider for SQL Server
>> Step Error Description:Syntax error or access violation
>> Step Error code: 80074005
>> Step Error Help File:
>> Step Error Help Context ID:0
>> Step Execution Started: 5/30/2005 11:40:46 AM
>> Step Execution Completed: 5/30/2005 11:40:46 AM
>> Total Step Execution Time: 0.157 seconds
>> Progress count in Step: 0
>> Step 'DTSStep_DTSExecuteSQLTask_1' was not executed
>
