Viewing 9 posts - 1 through 9 (of 9 total)
You are right Jeff, I'm using "\" when I define the global variable, so my global variable ImportPath equals to “c:\data_file\”
July 24, 2007 at 12:56 pm
answer to Luke L
No I don't have FailPackageonErrors set in the DTS, and I looked at the site you provided, it doesn't help
I'm suspecting "almost +" that its an issue...
July 23, 2007 at 5:16 pm
answer to mrpolecat
Yes, users.txt was not there but users.txt.tmp was there.
July 23, 2007 at 5:08 pm
Here is are the mains steps I have in the DTS
I have the following global variables
ImportPath, which equals to “c:\data_file” and
ImportFile, which equals to “users.txt”
FileExists, which equals to False “this...
July 23, 2007 at 12:28 pm
Just to let everybody know that I was able to load all tables from 2005 to 2000, I was able to move all tables' structure and 90% of the data...
July 23, 2007 at 10:05 am
Here is the ActiveX code I use to check for the existence of the file
Set objFSO = CreateObject("Scripting.FileSystemObject")
’’’ ImportPath = c:\data_file
’’’ ImportFile = users.txt
’’’ ImportPath and ImportFile are Global...
July 23, 2007 at 10:01 am
Well guys, I'm working on the same issue, I've tried moving the data from each table into a text file then importing those files into a 2000 db, I was...
June 19, 2007 at 9:14 pm
in my opinion a DBA is the one who can do "anything" that has to do with data within or outside the working environment, data import, export, cleansing, mapping, db...
May 25, 2007 at 11:22 pm
The way that I resolved this issue by uninstalling .Net FW and uninstalling SQL Server Reporting Services and then reinstall them again.
March 30, 2005 at 9:17 pm
Viewing 9 posts - 1 through 9 (of 9 total)