Hi,
I am having a problem here, since i am quite new to DTS programming.

I have made a DTS package (stored in SQL Server, but that shouldn't
matter) that basically takes an Excel file and impoprts the contents
into a SQL Server. The location of the Excel file will vary, and I
will eventually use vb.net to pass a Global Variable that will hold
the path to the excel file.

In DTS Designer, I have successfully created the package, along with
the "Dynamic Properties" task that sets the "DataSource" variable of
"Connection 1" to the value of my Global Variable "SourceFile". The
strange thing is, this keeps failing when I pass a string e.g.
"C:\testfile.xls" to that global variable. I monitor file access
using filemon, and it turns out that DTS tranlates my file location to

C:\Program Files\Microsoft SQL Server\80\Tools\BINN\"c:\testfile.xls"

Which makes no sense. After a bit of trying, I can specify a string
like

\test.xls

to make DTS open my file at c:\test.xls. But how am I supposed to
specify a file located at another drive than my SQL Server BINN
folder???

Hopefully I've overlooked something, and you guys laugh at me while
pointing me in the right direction :-)

Best regards,
Trond Hindenes

In article <c175a21a.0407151603.34fbc6cb (AT) posting (DOT) google.com>, Trond
Hindenes wrote:
Not seen this one before I have to say.

What SP are you running?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

I am running SQL Server Personal Edtn SP3 (build 8.00.760) on a Windows
XP box with SP1. My SourceFile variable uses a string datatype. Maybe I
would be better off by using a different type?

Best regards
-Trond

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <u0yAMuwaEHA.4032 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Trond Hindenes wrote:
String variable should be OK.

From what are you reading the value for the Global Variable?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Hi,
Thanks for replying.

Eventually, I'll use vb.net to specify the value of the Global
Variable, but I have tried to hard-code it into the DTS package as
well, along with specifying it using "DTSRUN /A".

I guess I could set up another machine and see if that behaves the
same way, since this seems to be a curious problem.

_Trond