Sometimes when copying packages strange things happen in the XML code.

For example, <none> can be replaced with _x003C_none_x003E_.

_x003C_none_x003E_ FlatFile Error in SSIS

Maybe this issue is related?

What if you explicitly set the location properties?

vijay.sap1255 (1/29/2014)

---

HI,

If you are using 64bit OS, better do the following step

Right click on Project and select properties. select debugging and make Run64bitRuntime False.

also try to check Delayvalidation (...

Maybe the cells in the excel file are formatted as currency?

Is the $ sign present in the original data?

Nice question. Never even heard of this tool.

sneumersky (1/28/2014)

---

I was running SSMS on my laptop as both the laptop admin and the SQL sysadmin when this happened. I even pasted the file path in windows explorer and...

Voted.

Sorry, I am stumped as well.

Your laptop has access to the shared network drive?

I could understand this in SSIS 2008R2 or earlier, as SSIS packages are executed on the calling...

Knowledge Hunter (1/26/2014)

---

Hello,

I have some SSIS packages which connects to SQL Server databases using SQL authentication.

This is working if I save the passwords in the package.

But when I try to...

You mean assigning a literal value to a datetime variable?

DECLARE @datetime DATETIME;

SET @datetime = '2014-01-28T08:26:14';

SELECT @datetime;

You...

Interesting question, thanks.

roryoflynn1 (1/27/2014)

---

Hi Koen,

Thanks for your reply...

I am thinking of coding the looping into the C# script, which is the first task...

The only issue I see with this, is that the...

rohit.kumar.barik (1/27/2014)

---

Hi

I am using sql server 2008 ssis package.

I am transferring records (around 20 laks) from one table to another.

It is very slow. taking around 30 mins to copy....

The set-up of the package is correct.

Retries in a SQL Agent job only work if it actually fails, which is not what you want.

You could create a stored procedure to...

Gail was apparently fast than me, but since I typed out that whole sp, I'm going to post it anyway 🙂

CREATE PROC MyLittleSumProc AS

DECLARE @sum1 BIGINT, @sum2 BIGINT, @sum3 BIGINT;

SELECT

...