It's impossible for me to know because I need a lot more info than can easily be provided on a forum, but you might be hitting a double-hop/fallback scenario.

Theory: when...

The cost estimates of all operators within a query execution plan are supposed to add up to 100%. If you're inserting a row then it should be natural to accept...

Never gave it a second thought but figured deferred name resolution should be in play during synonym creation. Thanks for the question.

Try casting all your string literals to NVARCHAR(MAX) BEFORE they are concatenated. The data type is likely being assumed to be NVARCHAR(4000) during concatenation because it is not specified.

Like...

Here is a great place to start learning about indexes in SQL Server, from the beginning:

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes[/url]

In theory a Script Component used in a Data Flow Task could work for you.

Some links that may help get you started:

Here is one that demos using a Script Component...

Does your bat file actually contain a call like this?

[font="Courier New"]java -jar E:\DH\Work\Simmetrics.jar %1 %2[/font]

If so, then %1 and %2 will take their values from parameters passed to the bat...

Nita Reddy (8/18/2014)

---

I want to export one table but text contains ',' so can I use double " ? I don't see option when I select delimiter how should I...

Gotta love their honesty 😛

Attached to this post is a simple SSIS Package * that will load your file to (a slightly modified version of) your POMaster table. I think you will need some...

Which feature or...

SanPoke (9/5/2014)

---

Thank you for your reply.

I set the "WatcherInputTimeoutAsWarning" = True and set the "WatcherInputTimeoutSeconds" = 10.

I have a FOREACH Loop to iterate through my "DatafileInfo" table. That FOREACH...

SanPoke (9/3/2014)

---

I'm learning SSIS and I have been trying to use SSIS to move files from different source locations to different destination locations. The files in each source location...

bart.de.koning (9/1/2014)

---

good Article,

I do not think the WMI Event handler is very reliable. I had it working for a remote UNC Fileshare but it often stopped listening without a reason....

In the case of Oracle being the target I would go with option 2 and avoid introducing the use of OPENQUERY.