I found a 'GetNumbers' function here [/url] and that, when combined with Jeff's function, allows you to take the CLR out of the equation ... at least for the data...

anthony.green (10/9/2015)

---

7 packages, a bit overkill.

Why not 1 package...

+1

garfieldlandry (10/8/2015)

---

If you change the target to a SQL Server table, does it work OK?

Do the columns which fail to be populated have anything in common? Same datatype, space in...

garfieldlandry (10/8/2015)

---

I am using a config file. The same config file manually as I use when running as SQL Job. The SSIS package moves data to an Informix table. It...

garfieldlandry (10/8/2015)

---

I have an SSIS package that extracts from Excel and loads to Informix db. The package uses a config file. If I run the package manually (package utility) it...

jellybean (10/8/2015)

---

Hi,

Can you help me please? I'm using the SQL indicated below:

SELECT

DISTINCT C.Field1 As 'Group',

A.Field2 As 'Security Object'

E.Field3 As 'User'

FROM TableA AS A

JOIN TableB AS B...

If you could post an example in consumable format, which others can run, it would be even better.

Jason Selburg (10/7/2015)

---

SELECT col1, col2, col3, CAST(NULL as BIT) as newCol4, CAST(NULL as VARCHAR(6)) as newCol5 FROM yourTable

in this example, newCol4 and newCol5 are your non-existent columns. Using the CAST,...

orenk (10/7/2015)

---

Hello,

who can I use a variable like the followig

set @MAG3 = '<> 0'

or

set @MAG3 = '= 0'

for the following where condition

where patindex('%;' + Mitarbeiter + ';%' , @MAG2)...

Deploy your SSIS project to SSISDB on your SQL Server instance. Here[/url] is a link that illustrates that process.

Now you are in a position to create a scheduled SQL Agent...

You just responded to a post which is six years old. I reckon all these 'bros' got...

helal.mobasher 13209 (10/7/2015)

---

I am using the following select statement to get the row count from SQL linked server table.

SELECT Count(*) FROM OPENQUERY (CMSPROD, 'Select * From MHDLIB.MHSERV0P')

MHDLIB is the library...

Clearly not using SQL Agent!

You'll need to use some other task scheduler. Or tell us why SQL Agent needs to be stopped while running these commands – there may be...

rajarajansudar (10/6/2015)

---

Guys i am building the custom logging framework in that i want get the task name ( Eg: get the data from source) which is currently executing ,...