For a true or false answer there is absolutely no point in setting variables. Cost time in setting up activex script and can be hard to debug. Worthwhile for complicated...

Have you tried checking here:

http://www.connectionstrings.com/

If you have a situation where you are looking for a true or false answer (as in your qery above), the easiest way to decide which route to take in...

DECLARE @LOWERDATE DATETIME

DECLARE @UPPERDATE DATETIME

SET @LOWERDATE = '2006-01-01'

SET @UPPERDATE = '2006-01-04'

WHILE @LOWERDATE < @UPPERDATE

BEGIN

PRINT @LOWERDATE

SET @LOWERDATE = @LOWERDATE + 1

END

You can play around with the output to change...

If:

a)The excel spreadsheet always has same number of columns

b)You want to import the same columns

c)The excel tabname is always the same

...You can use a dynamic properties task to change the...

Plenty, but not all of the ways are easy if you want to get them back.

Best way if you want to get them back quickly is to copy them onto...

As a rule of thumb, you appear to be doing the right thing.

Always bulk insert text files into an import and then use a stored procedure to shuffle the data...

I think the account will also need access to msdb as this is where the packages are contained in terms of system tables.

This will do it for you:

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

' Initialise dimensions

Dim appExcel

...

A quick and dirty way as follows. Not too good when it comes to performance but handy if you do not have permissions to create a numbers table in the...

See this link on this site:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=18439

I posted the code for this at another site.

See this link.

http://sqlobserver.com/community/index.php?topic=57.0

I take it that you are storing the images as a blob type.

If so, you will need to hack it out. I found this site a while back but never...

I would.

Call the dts package from the web page by passing in a sql server username and password when calling the package. Like so:

Extract from web page: http://www.sqldts.com/?208,2

============================================================

...

You will find that this encryption actually points to the current version of the dts package.

If you change the package over time, eventually the link gets lost and the encryption...