Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) * 100 + day(getdate() - 1));

Haven't been following that thread, but I do have some suggestions for your query. Here's mine, derived from yours.

select ServerName = @@SERVERNAME

,JobName...

OK, and please get rid of cur2:

insert Monitor.dbo.Procedurecode

(DB

,ROUTINE_NAME

...

ratloser99 36160 (8/21/2015)

---

Hi,

I like to backup the stored procedures' code used in my databases. So I created this Script:

/*

IF OBJECT_ID('[Monitor].[dbo].[Procedurecode]') IS NOT NULL DROP TABLE [Monitor].[dbo].[Procedurecode];

*/

DECLARE

@db nvarchar(50),

@strSQL nvarchar...

Try doing a Google search for SSIS IMEX=1.

It should fix your problem if you add IMEX=1 to your Excel connection extended properties.

Easiest solution: import from CSV instead.

Sean Lange (8/19/2015)

---

David Burrows (8/19/2015)

---

Sean Lange (8/19/2015)

---

Thanks. Shouldn't be too bad. This is a super simple process. No need for the "T" portion. Just need to truncate a staging table...

DamianC (8/19/2015)

---

Hello

I have inherited a few SSIS packages along with some jobs that run them.

I am able to find the packages behind pretty much every SSIS package as they're held...

The string format YYYYMMDD can be converted directly to datetime.

declare @x nvarchar(20) = '20110905';

declare @y datetime;

set @y = @x;

select @y;

Display formats are, of course, different from storage formats. It...

As far as I know.

karthik82.vk (8/19/2015)

---

Hi,

I have some excel files stored in a FTP folder. I want to transfer data from these excel files to my sql table directly from FTP without downloading it...

Rather than ExecuteSQL, why not use a standard dataflow with suitable source/destination components?

MikeTomkies (8/18/2015)

---

There should be no reason why the file system task wont move having the source and destination as variables. I use it for all file movements and with an...

Although it may seem as though the script components offer infinite flexibility given enough code, your problem will be that the input and output columns are defined at design time.

I...

Sure, use File.move in your script task.