Viewing 15 posts - 6,226 through 6,240 (of 11,678 total)
Make sure that the packages are stored and executed on that server.
For example, you can install the SSIS service on machine A on store them on that server, but if...
November 13, 2012 at 1:09 am
You can buy it on Amazon:
US
UK
France
Germany
and so on...
November 12, 2012 at 11:58 pm
Yes. Such a split is easy to do in the derived column and it saves you the staging step.
November 12, 2012 at 1:14 pm
edit: never mind, you cannot specify a length for DT_NTEXT.
What is the datatype of the destination?
November 12, 2012 at 7:25 am
Replacing a field doesn't actually do the conversion.
You need to create a new column and add the expression (DT_WSTR,32000)EmailBody there.
November 12, 2012 at 7:20 am
Roland is right, there's probably a one-to-many relationship, resulting in possible multiple results for one Dutyrostershift.ID.
November 12, 2012 at 7:18 am
Nice introductory article, but I would have liked another case study instead of the plain old BikeBuyer one.
November 12, 2012 at 6:27 am
solomon.jernas (11/12/2012)
What is this error?SQLServer Error: 3908, Could not run BEGIN TRANSACTION in database 'msdb' because the database is in bypass recovery mode. [SQLSTATE 25000] (ConnIsLoginSysAdmin)
Ah, that might be...
November 12, 2012 at 5:48 am
Please do not crosspost. It wastes people's time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1383543-5-1.aspx
November 12, 2012 at 5:27 am
solomon.jernas (11/12/2012)
running under generic domain account, it has sysadmin role..
The log says otherwise 🙂
There seems to be some sort of issue with this account, because the log mentions (unknown) instead...
November 12, 2012 at 5:26 am
asranantha (11/12/2012)
actual whil loading xls file extendent propertis=excel 8.0 and
...
November 12, 2012 at 5:23 am
Which account is used for the SQL Server Agent service?
November 12, 2012 at 5:18 am
http://stackoverflow.com/questions/18932/how-can-i-remove-duplicate-rows
Using Google for a bit probably won't kill you.
November 12, 2012 at 5:16 am
Did you check the SQL Server Agent error logs?
November 12, 2012 at 5:04 am
Viewing 15 posts - 6,226 through 6,240 (of 11,678 total)