I try not to use SSIS for Data conversions.

We usually just Import into a staging table then do all the data massaging in SQL.

Also if you create Stored Procs to...

What gets me most of the time are Carriage Returns, Line Feeds and tabs.

We receive many different file formats from different clients, while we try to standardize feeds as much...

I hate Excel...If your cutting and pasting into excel from SSMS, you could be losing leading zeros.

Usually the only time I do this is exchanging results among my team.

If I...

I am not going to write your code but here is the structure similar to used in some of my cursors (I don't like cursors but sometimes you just need...

How about Security, who needs access/what kind of access.

I posted my reply just to give the original poster something to test. I usually don't put sub-selects in my joins but If I am desperate I will consider...

Hello,

We just had a meeting a few months ago given by a DBA to us developers...

Big advice to us was to take the Items in a WHERE Clause (if you...

I did not go though all the replies but am throwing this out there.

I had to do the same thing a few years ago and here is how I did...

I had to insert headers through ssis, found out you had to install excel on server, but I ended up with one script task for formatting/adding header. This seems...

I say we resurrect John Wayne from the dead and have him monitor these forums....Pilgrim:-)

You also might want to check the schedules in Cognos.

As someone above stated, ensure you know where the data is coming from.

Are there any security settings you need to be...

Well I had to put results from an SP into a table and here is how I did it:

DECLARE @rc int

INSERT INTO [Database].[dbo].Table_to_Insert_Into ( SP_Column1 , SP_Column2)

EXECUTE @rc = [Database].[dbo].[Sp_to_Run]...

This sounds like a text book question...and my guess is it wasn't posted the way it was asked in the book.

Hmmm..Seems like there would be security concerns with this approach. Also doesn't seem to follow the KISS philosophy, don't know how junior developers would do setting up this as...

Interesting problem.

I started my career as an access developer and 15+ years later I am now a sql developer. If your boss doesn't truly know sql, he should not...