Viewing 15 posts - 61 through 75 (of 81 total)
Could it be something to do with the text file, does she have access to the file / directory and is she running from another machine (I'm thinking UNC pathnames...
March 3, 2004 at 9:39 am
what method do you use to run the package? I use global variables to hold the details and set the connection first, if you run the package from dtsrun in a stored...
March 3, 2004 at 2:59 am
If you only have one destination connection shown on the package then you can't order them as you say. I think that you're right to add the additional connections to...
February 25, 2004 at 5:02 am
You can log the dts package run by going to the package properties and entering a file name into the Error File box. This will show details of the whole...
February 25, 2004 at 4:28 am
I seem to have found the solution, not as difficult as your first solution but not as simple as the second. I have several packages that are run from the...
February 18, 2004 at 6:00 am
That's really great, but unfortunately not exactly what I'm after. What I have is an execute package task. The directory that the .dts file is held in is passed as...
February 18, 2004 at 2:46 am
Well I'm getting the hang of this. If you set a global variable to space and then use dynamic properties to set the version id to that then it will...
February 17, 2004 at 8:05 am
Surely the activeX task will be there even if you are re-distributing dts on it's own. I'm not aware of any T-SQL that will load a package, so I think you...
February 3, 2004 at 2:51 am
On the options tab for the transform you can set a max error count. The default is 0 (no errors allowed), set this v. high. I don't know if there...
February 3, 2004 at 2:35 am
You could write a package to load packages using an activeX. Parameters (filename / package name) could be passed as global variables (use -A to pass global variables to the...
February 3, 2004 at 2:26 am
I did try openquery but the results were the same. Unless I have some major suggestions I think I have to give up.
November 24, 2003 at 5:27 am
If this text file is now a comma delimited file you can dts this in to MS SQL. Possibly there is some ODBC connections to the HP3000 (image files?)...
May 30, 2003 at 8:41 am
I've been testing this on my own PC which has SQL, Oracle client and ODBC connection. The Oracle I'm testing against is on Windows 2000 but may be on...
March 21, 2003 at 5:12 am
Via,
I think DTS may optimise these things a litte. What settings did you use for your linked server?
March 20, 2003 at 9:08 am
Query runs fine from either SQLPlus or within a dts transformation query
March 20, 2003 at 8:40 am
Viewing 15 posts - 61 through 75 (of 81 total)