Hi,

Check this link: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=61765&SiteID=1. Hope you find your answer here...

Hi,

What you could do is:

In the Parameter Mapping tab click on Add and create a parameter to map with the variable you had created.

In the Execute SQL Task General...

Hi,

I reckon what you need is to execute the package along with its configuration without having to always select the configuration file from the DTExecUI utility. Therefore you look for...

Hi,

Could you give a little bit more  information regarding this? I am of the impression that you need to only added new record if GM-Hello-1 specifically exists in the flat...

Hi,

I assume that you are using a Data Flow Task, and that you need to write a SQL statement in the data source which would filter data based on...

Hi,

Does your password contain punctuation symbols (ideally a semicolon ";")? If so try supplying your password within double quotes.

Let me know if it works.

Hi Tim,

Instead of checking for NULL, try checking for an empty string like the following in the derived column expression:

[LaborRateEffectiveDate] == '' ? [ActivationDate] : [LaborRateEffectiveDate]

Let me know if...

Hi,

I assume that you are using an Execute SQL Task and an OLEDB Connection Manager. In the SQL statement that you have given above the ? placeholders should not be...

Hi,

I found a few links to problems faced by others which are similar to yours. Hope you could find a solutions here:

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1417123&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=925127&SiteID=1

http://www.eggheadcafe.com/forumarchives/sqlserverintegrationsvcs/feb2006/post25445179.asp

Regards,

Gogula

Hi Ryan,

The error message shows that it is a Send Mail Task error. Do you have any Send Mail Tasks in the same package, maybe under the Event Handlers tab...

Hi,

I suggest you use the first option (Script to file) instead of the second. The second option is to publish your database to server on the web or so.

After creating...

Hi,

You could also try the Microsoft SQL Server Database Publishing Wizard, which can be used to transfer all objects and data from one SQL Server to another.

Regards

Hi,

This could most probably be because Access and SQL Server have some differences, and the data that coming in from Access could be incompatible with SQL Server. Also, check if...

Hi,

I have noticed that you are converting the field into Numeric(5,0) which I gather is full numbers, right?

Anyways, I simulated your problem and the same problem occurs. By changing the...

Hi,

SSIS is a fully fledged ETL tool, and as with DTS, you need not worry about the table structure and number of fields not being the same (or even the...