Search results for query: *

Insert char(13) carrage returns into your text string: Example: 'This is line one ' + Char(13) + 'This is line two. ' char(9) can also be used for tabbing.

A couple of things to consider! 1. When you say schedule, if you mean SQL Server Agent, the permissions for the account that starts up the SQL Server Agent service are used. 2. When creating a file to the network, are you using the UNC to the network folder or mapping a drive. You should be...

You should probably use "LONG" or "SHORT" when adding to the ParameterMapping. How is the field defined in the database table? SSIS is more strict about data types than DTS was. If you haven't tried them yet, Expressions are another way to code parameter queries. They are a little...

I would verify your connection string from the General tab of the Execute SQl task in SSIS. 1. Are you using an OLE-DB Connection Type? 2. Verify that the connection is actually pointing to the database you believe it is. 3. Does the parameter mapping section have the right variable and type of...

Does this statement work outside of SSIS (replacing the "?" with an actual value or variable)?

Is NewsletterID in the HouseholdNewsletter table? If so, the where clause should read: Where b.NewsletterID = ?

See response in thread: thread961-1267491

Actually the alias the message is referring to is the one you have qualified in the set statement I usually perform update statements as follows: update PushmailListGen..tmpNewsLetterSync set stauts = 1 from PushmailListGen..tmpNewsLetterSync a join HouseholdNewsletter b on <join table fields...

Is HouseholdNewsleter in the database that matches the connection string? Was it created by owner dbo, or is it a user table?

...correctly. You may have to fake out the script with a dummy select statement based on the parameters you are passing in Ex of 2 parms: Select * from employees where first_name = ? and last_name = ? Make that the first statement, comment out the other ones, setup your input parms, then...

Hi Margaret, Are you running this interactively or from SQl Server Agent. I notice you are using a UNC naming convention. Is it possible the package (based on the service account if "SQL Agent" or current user if interactive) does not have permissions to this network drive?

Another option is to use File System Object (FSO) within an ActiveX script to rename or move the files to a different folder. This examaple adds a "U" prefix to the file name and keeps it in the same folder: Dim fso Dim strFile Dim strPath Set fso =...

See if this works for you. I haven't tried it since I don't have a copy of your tables but it should work. UPDATE salesorderdelivery SET sod_csa_recordid = sts.csarecordid FROM salesorderdelivery sod INNER JOIN shiptospecial sts on sts.somrecordid = sod.sod_som_recordid

Ooops!! Sorry about that... Anytime!! Glad to hear you got it working...

Is it possible the "dbo" is not the owner of either the source or destination tables? If so, you will want to replace .dbo. with the actual table owner.

Glad to help -- hope it works for you!!!

...statement select @varDBName = [name] from master.dbo.sysdatabases order by crdate desc SET ROWCOUNT 0 -- Create dynamic SQL statement to insert rows from new database table SET @strSQL = ' INSERT INTO MyDatabase.dbo.Webproxylog SELECT * from ' + @varDBName + '.dbo.Webproxylog ' Exec @strSQL

...asking how to send emails or how you would condition the sending of an email? If it's the latter.... I would suggest you perform a Select Count(*) from ... on the criteria you are using to create the text file. Store the result of the count in a Global Variable. In a separate task...

The User:: prefix isn't really required unless you use the same name as a System variable. I use it just for clarity. Glad to hear it worked!!!

Sorry - one correction... The VariableName value should be User::cnt (without the @ sign).