November 12, 2010 at 8:02 am
Hi,
It's my first try with SSIS, so sorry if it's a stupid question.
I'm migrating a DTS package to SSIS. In the DTS, I have an ActiveX Script that set a variable (filename with date and time as the file extension) and a Dynamic Properties Task that set the filename to a Text-File destination feeded by a Transform Data Task that uses a SQL query that extract and format the data to the required field-length. That works fine.
Now, I need to do the same in SSIS. Flat-File Connection Manager ask for an existing file. But this file is created by the DTS, it doesn't exist yet. And anyway, filename should be dynamic.
I tried Raw File, where I can select a variable as filename, but the output is binary.
The result file is imported by a SAP ERP system, so it has to match the required fix field-length.
how can I do this in SSIS?
thanks for your time and help
November 12, 2010 at 12:48 pm
When you place the Flat File Destination component into your Data Flow, you can create a New flat file connection manager. In your case, once the output connection is created, you will probably have to use the Advanced Editor, to tweak the output file to the SAP file spec.
See this re: file date-time stamp
November 13, 2010 at 5:14 am
ok good! thanks for the link!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply