Viewing 15 posts - 1 through 15 (of 56 total)
No event handlers in the package. We have some other packages that when they fail they send an email. Those were created by another admin who has left the company....
March 31, 2014 at 3:05 pm
Hi - that is correct the primary key conflict is failing the package. When the primary key conflict comes up I would like to see the job fail and the...
March 31, 2014 at 2:31 pm
In the SSIS package I have a Select Statement to query the SQL Server (A)
February 27, 2014 at 10:35 am
Thank you for the fast response. You stated
To avoid this problem, you should do an explicit conversion.
My column is Revenue (float, null)
How would I do the explicit conversion?...
October 22, 2013 at 1:51 pm
Thank you for the responses. I will try and post with my results when we try it out.
Regards,
David
July 24, 2013 at 10:08 am
Rinu -
Thank you that is what I was looking for.
Regards,
David
July 19, 2013 at 6:41 am
Lynn -
Thank you for the tip.
I used dateadd(dd, datediff(dd, 0, d.DocDate), 0)
but how do I get rid of the
"00:00:00:00"?
Thanks,
David
April 24, 2013 at 12:41 pm
Thank you for the response...
Would they be able to run Select statment from SSMS on any of the tables? I just tested that and they could. Is there another way...
February 13, 2013 at 2:05 pm
I was able to find out what it was. There were two rows I removed that I didn't remove in the last Select.
Thank you both for the reply's
Happy Holidays!!
December 14, 2012 at 1:38 pm
Oh I understand the message. Its my eyes that are not seeing where the issue is.
December 14, 2012 at 1:02 pm
srkrell (8/24/2009)
I had the same problem and discovered that changing the datatype in a derived column from unicode text stream (DT_NTEXT) to Unicode String (DT_WSTR) cleared up my problem.
Srkrell -...
August 28, 2012 at 12:21 pm
You did not mention what do you have in instance A. From the thread I assume you have replication.
Any logshipping /mirroring. And what kind of replication you have.
Instance...
August 23, 2012 at 7:12 am
We have one Excel file with data that needs to be uploaded every month. In my database there are two separate tables (Table A and TAble B) that I need...
August 17, 2012 at 1:55 pm
I would agree and would like to use the Multicast. I attached a image of what my Data Flow looks like at the moment.
How can I upload my excel data...
August 16, 2012 at 2:03 pm
Never used it. But why not just multicast from your Excel source.
That was my first approcah but then when writing the SQL command in my OLE DB Destination I didn't...
August 16, 2012 at 10:35 am
Viewing 15 posts - 1 through 15 (of 56 total)