Hi ,

I have a similar problem.

I have a set of files with dates and time, in the form of YYYYMMDD_HHMM.

I have to pick the latest file and load it.

I...

Thanks for pouring in your ideas

Staging table as in physical table or a temporary table ?

Which one would work efficiently ?

Please reply.

Thanks

Staging table as in temporary table in the Database and then update tableB and tableC ?

I can learn it if I don't know it with your help 🙂

Other appraoches ?? Can you suggest, how else can it be done ?

Thanks Phil.

I am trying it out your way.

I am having trouble since the dll - 'Microsoft.Office.Interop.Excel' is missing.

I have installed the dll but I do not know how to add...

CozyRoc,

another quick question regarding the same.

I could do it because the woskheet names were extracted from filenames.

How to solve the same issue where the filenames and worksheets aren't related ?

example...

Thank you very much! I got it!

and in order to execute each step in control flow tab, right click each of the tasks and click on Execute task

1) truncate table, Use SQL task ( Control flow tab)

2) transfer data from flat file to table , Use data flow task in control flow tab and then , use...

Thanks to all of you for the response.

Hi,

Can you help me out.

I have the same issue, I see square characters in the preview of the file.

How did you resolve the problem ?

Thanks in advance!

hey Jack,

I did look into the Union ALL transformation.

I need a single record in table from 3 records in the file.

The Union ALL gives me 3 records and I need...

Its possible with the help of 'ragged right' option in the connection manager of the file in general tab. Then switch over to the Columns tab and decide on your...

hey Jeff,

Yes, As I had written earlier that certain records have fixed length.

Like say

H1234NRina

H2345A123abcstreet

H3456Z23456

Above, 1st record "type" i.e. type N will have columns of length 5,1,4 only

Similarly, 2nd one,...