s.kandepi3 (8/15/2015)

---

found it.. it is getting converted to int in the view. so removed the cast in the view and let it flow as varchar.. and then in the derived...

s.kandepi3 (8/14/2015)

---

my package gave me this error.. the varchar value xyz cannot be converted to datatype int.. how to do error handling for such conversion errors? I tried the following...

Do not put the password in an expression.

Mirroring, yes.

Log Shipping, not as far as I know.

Yes...

happy55 (8/13/2015)

---

I have an SSIS Project which has few packages .All of the packages involve transferring file data to/from database to flat files. I am confused if I need...

Or pass it in via a 'sensitive' environment variable if SSIS 2012+.

Using not-very-advanced Google search strings suggested yes.

Try this.

Use a UNC path. Do not rely on network drive letters.

Charmer (8/11/2015)

---

Thank you Phil, you gave me an idea

but Just curious...Is there a way to get it on the GO?

Like we get the below informations....Just curious...through vb/c# coding?

FileInfo fileinfo;

...

Sure, just read the XML inside the file and find the value of the DTS:CreatorName property.

Charmer (8/11/2015)

---

Hi Friends,

In SSIS, I am trying to get file attributes through script task. I am using FILEINFO method to collect those information. I could get all the details but...

ravi@sql (8/11/2015)

---

HI Folks,

Is it possible to replace while loop by CTE?

I will fetch records from table 1 based on tretmentid.

get the count of records

run the while loop

inside loop...

Is the package which you have modified definitely the same as the one which is being executed?

What the devil is this?