I've now had a chance to ask the DBA/owner of the db that had caused the original performance issue why there are so many tables without clustered indexes. Below...

Make sure you chose the correct end of line character(s). If the import wizard is looking for <CR><LF> and your data file is delimited by only <LF>, the...

I'm not totally following what you're asking, but if length is so important couldn't you bring this all in as strings (or one big long string) and parse it out...

Running the Data Profiling Task in SSIS against a table in the db can be quite helpful.

In cases where I have to write out parent and child records with FK relationship between them, I use a stored procedure so I can get the @@IDENTITY of the...

The answer looks to be no as the formatting is determined by the Jet driver. See: http://www.bigresource.com/Tracker/Track-ms_sql-mw5YvkBz/

Is there a reason you're not using Reporting Services? It sounds like it would fit most of your needs.

Chris,

Wouldn't your SQL miss the case:

Acct2 Sec77 Only in Account

I was playing around with this; that's the only reason I ask.

MuraliKrishnan1980 (7/20/2011)

---

[font="Tahoma"]

I am new to SSIS. I am trying to create an extract by joining few tables. I just wanto to know if we should convert the column values to...

Do you want to see which columns allow Nulls? You could script the table's create statement out and look at the DDL where the column allows NULLs. That...

For many small and medium companies, price is a big factor in MS SQL Server's favor over Oracle. While being less expensive, it also includes SSIS, SSAS and SSRS...

It looks like I found my answer at:

http://agilebi.com/jwelch/2008/03/11/using-the-data-profiling-task-to-profile-all-the-tables-in-a-database/

What have you done to investigate Gail's answer to you? I think you were pointed in the correct direction to look at the system...

Take a look at this thread: http://www.sqlservercentral.com/Forums/Topic929630-391-1.aspx

As Ron said, "Yes". You can prove this to yourself by playing around with something like:

DECLARE @Animal1 table (name varchar(20), weight smallint)

INSERT @Animal1 (name, weight) VALUES ('Gazelle', 250),

...