DSXchange

Did you read the rest of the post? [/quote]
Yes. working on how to pass the varaiable or routine.

[quote="chulett"]You passed what variable 'like this'? Never mind, here's a quick overview of what you need to do...

In the UV activity I hvae passed this value in expression.

Thanks,

What 7.x version - a 7.5.x version? If so, then you should have the Loop and User Variables stages available for Sequence jobs. Those were added for exactly the kind of thing you are trying to do. The User Variables stage gets a list of the files in the dropbox. That is leveraged by the Start Loop ...

I have the similar issue ,to read the XML files from ds dropbox. My file name is XXXXXXXX_1000001_1000062_20070212_195455.xml <Interfacename>_<ClientID>_<BID>_<Date>_<hhmmss> Everytime the BID and Timestamp will be unique for each file. When I ftp the the files from diff server to my ds server I hav...

we are using Parallel, Windows, Sql server 2005 we are getting like this in Flat files 7/6/2004 5:00:00 AM 8/15/2005 4:59:00 AM 11/21/2005 4:22:22 AM Target is sql server using datatype TIMESTAMP. need to be converting into 2004-07-06 05:00:00.000 2005-08-15 04:59:00:000 2005-11-21 04:22:22:000 if ...

Is this issue has been resolved

Hi all, My file name is : " <Interface name>_<0>_20060501_192056.xml " My design is I have to pull the files from diff server and get the ftp filesand drop in ds server and process files one by one. In the file '<0>' and the '<Interaface name>' will be the same except the timestamp. I am n...

Try changing it. Also, since this is such a struggle, load it to a flat file, just a few records to see how it looks like. It should have two parts. The first is date in the format YYYY-MM-DD and second is time in the format HH:NN:SS. Both parts should have a single space in between them. I tried t...

Try changing it. Also, since this is such a struggle, load it to a flat file, just a few records to see how it looks like. It should have two parts. The first is date in the format YYYY-MM-DD and second is time in the format HH:NN:SS. Both parts should have a single space in between them. I tried t...

Does'nt SQL Server take timestamp in YYYY-MM-DD for date and MTS format for time? Does the following work for you guys OCONV(ICONV(Field(in.DATE, " ", 1), "D/DMY"),"D-YMD[4,2,2]):" ":OCONV(ICONV(Field(in.DATE," ",2), "MT"), "MTS") in....

ray.wurlod wrote:It is the input field column name, qualified by the name of the input link. ...

Do I need to change the sql type from Timestamp to varchar because its not loading anything if its Timestamp.

Does'nt SQL Server take timestamp in YYYY-MM-DD for date and MTS format for time? Does the following work for you guys OCONV(ICONV(Field(in.DATE, " ", 1), "D/DMY"),"D-YMD[4,2,2]):" ":OCONV(ICONV(Field(in.DATE," ",2), "MT"), "MTS") in....

I have the similar isuue:

I have to convert string to Timestamp
sample input date: " 1/10/2007 2:19:16 PM "

Thanks in advance

Did u import .xsd file or .xml file . If u have schema of that particular file then u can modify and add one more arrtibute.
Let me know If I misunderstood anything.

can you explain in deatil in which stage ur facing this problem.