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

So you are using package configurations to store the sensitive information inside a SQL Server config table?

It's a wizard. By defination a graphical user interface designed to guide a user through a certain process.

Why would you ever want to call that from a trigger?

I don't think you can.

That would require the SELECT statement to return results skipping certain rows, which is practically impossible without an ORDER BY clause and hence virtually unfeasible to...

Yes, and that's probably where your confusion comes...

Nice question and interesting discussion. Thanks.

The behaviour should not be dependent on the OS.

What is this "SSIS new project for flat file conversion "?

There are only two ways of developing SSIS projects:

* Project Deployment Model:...

Haining (6/9/2012)

---

In the question, it states that "When you build an SSIS 2012 project in the Project Deployment Model, what kind of file is generated in the /bin/Development folder?"

So, if...

Jan.Sundbye (6/8/2012)

---

opc.three (6/7/2012)

---

Koen Verbeeck (6/7/2012)

---

I don't think you can...

If you do a preview in the flat file source, does the data look OK?

I'm not sure about the current generation, but I had issues with mine as did a coworker.

My MBP was about 3.5 years...

Be prepared to change your battery after a while 😀

Stupeo (6/8/2012)

---

Well, I finally took the plunge and upgraded my RAM from 4GB to 16GB (even though Apple says they only support 8GB :crazy:) and then installed a OCZ Agility...

Why don't you just assign a sequencenumber to the same incident references, instead of this overly complicated datetime function?

If you would get rid of the function and the subquery, tune...

Stewart, this discussion is continued in another topic:

http://www.sqlservercentral.com/Forums/Topic1312885-391-1.aspx