September 12, 2013 at 3:59 pm
Hi All,
Greetings!!!
I am new to DTS and i need some help regarding the following
Our environment is SQL 2008 but we have 2005 backward compatability pack on our server so we have dtsrun.exe.
We have the DTS placed on a shred drive and by using xp_cmdshell we run the dts packages. Our application was based on MS Access before and now we are trying to migrate to Java. We have a stored procedure that we call from java to run the DTS.The Java application will run on a unix machine.
Currently we are able to execute the DTS from the java application but we are facing difficulties updating the global variables. I tried this
exec databasename..xp_cmdshell 'DTSRun.exe /a VariableName:String="21713-1" /f "D:/DTS/Load table.dts"'
but when i execute this the query is running for long time and nothing is happening.
I also have one more DTS, which accepts the input file and updates the tables. The user can browse the file from any location and upload.
In the DTS, if i right click for the connection properties we have a kept the datasource as text source and hardcoded a file name now. How can we update the file name location from java.
This is what we have in Access application
myPkg.Connections("Load File").DataSource = stFile
Please help
September 13, 2013 at 8:04 am
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1494391-391-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 13, 2013 at 9:09 am
Hi Sean,
I posted the same question twice because my browser got hanged. I will try to delete one of the posts.
I dont see any replies posted on my other post too
http://www.sqlservercentral.com/Forums/Topic1494391-391-1.aspx
Did you mean some other posts has solutions to this
September 13, 2013 at 9:18 am
sasi4frendz (9/13/2013)
Hi Sean,I posted the same question twice because my browser got hanged. I will try to delete one of the posts.
I dont see any replies posted on my other post too
http://www.sqlservercentral.com/Forums/Topic1494391-391-1.aspx
Did you mean some other posts has solutions to this
No problem. Sometimes that happens. Many of us around here browse the recent posts and it is best if a thread is kept to a single post. That way anybody who has potential answers can put them all in one place. Many times the best answer comes after several different people look at the same thing.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply