Hello,

I was wondering if converting the column values before extracting would be useful and i got the answer from one of my colleagues. Thanks for your response.

[font="Tahoma"]

Hello Elliot, Seems that the package is corrupted while it was transferred through email. But not sure. It is only 2 bytes. :blink:

[/font]

[font="Tahoma"]

Nope. Nothing is there when i open the file in Notepad. I too am surprised about this. However, i do not have BIDS installed in my system. Could it be...

[font="Tahoma"]

Thanks for your response Koen. Yes, i tried opening the package in notepad as well. As you told, that package seems to be corrupted and its opening a blank page...

[font="Tahoma"]

Hello Welsh,

Its doesn't really matter if its an INNER JOIN or LEFT JOIN or RIGHT JOIN. Every column in the tables joined would be returned if you simply use *...

[font="Tahoma"]

First of all, Left Join does not return only the matched records. It returns all the records from the Table which is on the Left of the Join along with...

[font="Tahoma"]

Hello Gail,

I am really sorry for posting the same topic in 2 forums. I did not get the intended reply. Hence i posted the same in this forum as well....

[font="Tahoma"]

Hello Lutz,

Thanks for your response. Yes, i was able to drop the tables using dynamic query. But i just wanted to know if it was possible in the way that...

[font="Tahoma"]

Hello Thanks for the response. I have already declared the variable and mapped the same. I am attaching the package for your response. Kindly check it and let me know...

[font="Tahoma"]

Removing the header and adding it manually seems to be a better option. Thanks for your help..:-)

[/font]

[font="Tahoma"]

Hello John,

PFA for the exact format of the file. The content did not get copied in the exact manner as it is in the file. Hence i have attached it.

[/font]

[font="Tahoma"]

Hello John,

PFB the sample data that i have in the file.

Department SubDept EMP NO ...

[font="Arial"]

Thanks for your response John.. As i had mentioned the file is not properly formatted. The columns are not seperated using fixed width. They are seperated by varying width.

What...

[font="Tahoma"]

Hello Bob,

I am not sure if we would be able to include columsn to store the values of the variables in the table created by the sql server log provider.

sysssislog...

[font="Tahoma"]

Thanks Brian and Koen for your replies. I created a user defined table and added entries to those tables through [sp_ssis_addlogentry] sp which got created after enabling Logging through SQL...