dbTalk Databases Forums  

global variables etc

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss global variables etc in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dirk
 
Posts: n/a

Default global variables etc - 05-16-2004 , 04:21 PM






Trying to run the looping script by Allan Mitchell (http://www.sqldts.com/default.aspx?246

Keeps telling me that I've got a bad directory

Two questions, Not being familiar with DTS, why does it keep changing the file that I give it in the global variables from a *.txt file back to a Desktop.ini file? Damn thing acts demonic

Anyone else have this bad directory error message when trying to run this package? Solve it?

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: global variables etc - 05-17-2004 , 09:01 AM






Have you terminated the directory with a \ ?

I presume the directory does exist.

The file shouldn't be changed at all. It should be the file you pass in. I
am not sure where you get this though. Is it in the loop and it picks up
the .INI file?


"Dirk" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Trying to run the looping script by Allan Mitchell
(http://www.sqldts.com/default.aspx?246)

Keeps telling me that I've got a bad directory.

Two questions, Not being familiar with DTS, why does it keep changing the
file that I give it in the global variables from a *.txt file back to a
Desktop.ini file? Damn thing acts demonic.
Quote:
Anyone else have this bad directory error message when trying to run this
package? Solve it?




Reply With Quote
  #3  
Old   
Dirk
 
Posts: n/a

Default Re: global variables etc - 05-17-2004 , 06:06 PM



Yesy, I have valid paths and they are terminated with a
For the gv_FileFullName

I pass it the name
D:\My Investment Databases\Stock_Quotes\Quote_Data\Process\AA.tx

and this is what the gv_FileFullName looks like in the Properties tab
D:\My Investment Databases\Stock_Quotes\Quote_Data\Process\Desktop. in

weird !

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.