Without seeing actual examples of the data you are looking at this may be a bit difficult, but I have to ask the question, is your data not comma delimited...

Had a similar situation recently, where source usually sent nulls, and I cast the date as integer (YYYYMMDD).

Suddenly they started sending blanks (''), and it defaulted to the date that...

If you have database mail configured, this would mean that the SMTP is running fine right?

So in order for you to use the send mail task in SSIS, you would...

You could use a derived coumn.

- You would have a variable called varFieldName with a scope of package

- In your derived column, you would have something like:

YourDerivedColumn (Derived Column Name)

@[User::varFieldName]...

If its for experience, it would be fine.

But ultimately, the sooner you can get it done (in other words at source), the better for your SSIS package

Are you importing this as date (DT_DBDATE), time (DT_DBTIME), or as datetime (DT_DBTIMESTAMP)?

Are you sure that the content of the file is truly date and time?

I suggest you import as...

Note bing the kind of person to hang around and wait, and after a frustrating morning on google, I managed to locate some really interesting examples.

But the one that did...

This article seriously rocks man...

Specifically delving into the planning session.

Thank you sooooooooo much 😎

I am using the varRunBalances as a boolean variable which will indicate that my control flow is still in balance .

For example:

I have a source file, and a checksum file...

Quite a lengthy stored proc this one...

:blink:

Agreed:

- check the access plan, select statement by select statement and eliminate those table scans

- Creating a temp table is really not a bad...

GSquared meant to put @table...

Syntax:

declare @table table(identifier int identity(1,1), ModuleID tinyint)

insert into @table (ModuleID) values(1)

insert into @table (ModuleID) values(2)

insert into @table (ModuleID) values(3)

declare @counter tinyint, @ModuleID tinyint, @string varchar(max), @maxcounter...

Also try and establish what datatypes are being used on the table

That few records versus that amount of space....

Possibly a few of the char fields could be converted to varchar...

Agreed, but it all depends on the performance bottleneck if you were to draw a report across clients.

Querying multiple databases may kill you on volumes.

However, in terms of the flexibility,...

Something like

DROP SYNONYM MATRIX

CREATE SYNONYM MATRIX FOR MYDB.MYUSER.MATRIX_B

GO

Now when your agent job runs

DROP SYNONYM MATRIX

CREATE SYNONYM MATRIX FOR MYDB.MYUSER.MATRIX_A

GO

to use, all your queries would pull from MATRIX:

Select Fields from MATRIX

GO

Not...

You could create a table valued function, which stores the values in a resultset.

Temp tables wont be stored in here, but its almost the same...

Sample Code:

CREATE FUNCTION YourFunctionName (@VariablesYouNeedHere )

RETURNS...