That wouldn't really have worked in...

Do you get any validation warnings? Any configuration warnings? (you need to log them,...

Jonathan Marshall (6/11/2012)

---

Is there a better way of loading data of a hundred million+ rows.

If it fails you have to start from the beginning and lose over a days...

Thanks...

This one seems to be the original:

http://cm-bloggers.blogspot.com/2009/05/sql-server-2008-star-join-query.html

This one doesn't:

http://blog.sqlauthority.com/2009/12/04/sql-server-2008-star-join-query-optimization/

A question for the more wise people here in the thread:

I may have found a copyright violation of a long time SQL Server MVP (not active on this forum as...

sqlstud (6/11/2012)

---

Hi

As already said

It is Fixed length Format.

There are no delimiters in the file so when one field ends, the other starts without any tabs, comma(s), or spaces between them....

Check the config table if the password is stored correctly.

If you generate the data using the wizard in BIDS, it stores the password as ***** instead of the actual password.

That is your most awesome feature of SSIS 2012? There are...

Did you do step 1:

Otherwise, you won't see the control flow items as Matt already suggested.

It might help to write the query in a more readable format:

DECLARE @ID= ?;

DECLARE @Year= ?;

DECLARE @Param1= ?;

DECLARE @Param2= ?;

DECLARE @Param3= ?;

DECLARE @Param4= ?;

DECLARE @Param5= ?;

SELECT

id

,column1

,id_date

FROM SII.COMBO_2011_VW

WHERECONVERT(VARCHAR(30),ID) = @ID

AND...

It's very very easy in SSIS. Just create a flat file connection manager and explore the...

If you find out the requirement, would you please post it here?

I'm very very curious why one would want to do such a thing.

No. The question is about project deployment model and which...

Did you tried Google? I cannot imagine that typing in "ssis import file fixed length" wouldn't give any meaningful result.