In those 5.5 years, did you ever work with SSIS, SSAS or SSRS?

BI developers will be in demand in the future, but their skill set will probably go beyond those...

Developing a Time Dimension with SQL Server 2008 R2 Analysis Services

I never use those. Great question though.

Phil Parkin (10/23/2014)

---

Koen Verbeeck (10/23/2014)

---

Phil Parkin (10/23/2014)

---

Configure your flat file source connection with | as the column delimiter and let SSIS do the work for you. See here[/url] for an...

Sure. It's a pretty decent written article.

Hope to see more of you on this site.

Or just create a...

Nevyn (10/23/2014)

---

I don't know how you would get a server without the 64 bit utility unless its a 32 bit server. I believe the 64 bit installs by default,...

I got it from this thread:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2354ca36-9c2a-4a08-b22c-59a511d302c1/suggest-column-types-flat-file-connection-falls-flat?forum=sqlintegrationservices

There is no documentation on this limit, that's why I had to test.

It's possible the limit is now 20,000 for example, I wouldn't know.

I tested...

Yakov Shlafman (10/23/2014)

---

Koen,

thank you very much for your input.

The max number of rows the Wizard can scan is 10,000.

I need the script when an input file has more than...

3party software. Can't live with it, can't live without it.

You can check for NULL values with the IsEmpty funtion. For empty strings you can simply check the length of the string. If it is 0, you don't need to...

1. There is no need to write a VB script to find the maximum lenght for all the columns. You can just click the button "Suggest Types" in the wizard....

Don't use SaveSensitiveWithUserKey. Exactly for the reasons you just mentioned.

You cannot reset the user key.

Either change to DontSaveSensitive AND store the usernames and passwords in a configuration, or change to...

Empty as in NULL or empty as in an empty string?

This is a known bug:

Pasting objects with expressions pastes fully qualified functions