Thank you 🙂

Hi,

Sorry I took time to replay. Ive a question about your post. If I do 52 logical partitions, I will have data from different years. I mean, week 1...

Hahahaha, I'm just making fun of myself. This is easier than I thought. I have changed the SSIS like 5 times. I had the flat file in my second data...

I found something interesting in my first Data Flow.

since my Table1 has an Indetity Key Column, when the lookup redirect the Error output (or data that doesnt exist). My Identity...

How I can read my values from the Flat File in my second Data Flow ? when I do my Join (lookup), my MSO table join only with a value...

Wait a second..

for my destination table I will need to join Table1, MSo and BulkTable..

If Im not using a bulktable, then it should be Table1, MSo and Flat...

ah! that's why I got errors.. mmmh, it makes sense then.

I just did 3 Data Flow, the first one was the Bulk table, the second one insert into the Table1...

I tried what you mention. But, seems like the data from the flat file go all the time to my Table1. The data should go to BulkTable and Table1.

Take a...

This has been a good topic 🙂

a) I will archive data, this will be history information. Any advice?

b) queries will be only to load data into the table and reporting...

Good Morning!

I really got confuse. I'm sure this is pretty easy, but ITs new for me. Here is a print screen of my SSIS. I already have the FlatFile and...

Thank you for the advice..

now, I have a question.. if I improve my SSIS package. Is a reason to still make a partition on my table? or not?

Regards,

thank you John,

I will star working on it first thing in the morning. I really want to make it works 🙂

I already have am OLE DB Destination that connects...

I fixed the problem. I just re installed the Integration Services component and it worked.

Thank you for the advices

I’m sorry for the delay. What I need to do is to insert information into the Destination table coming from the BulkTable, Table1 and MSO Table (third query). Because I...

Im lucky Im not alone 😛