Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. QuestionAsker

    Datepart

    SQL Server 2005 Hi All, Being a bit blonde here, but i have a problem I hope you can help me with. I have a stored procedure that has a Date parameter that is fed in. For a calculation I want to use this date like this Tran_date <= day(01) & datepart(month,@date)-1 & datepart(year,@date)...
  2. QuestionAsker

    OLE DB Connection Issue

    ALL SQL 2005 Enterprise Windows 2003 Server I'm trying to connect to an Oracle 9i table with SSIS. I have connected to all the tables i need to in the same DB no problem, but when i try and access one table i get the following error message. rror at Data Flow Task [OLE DB Source [492]]: An...
  3. QuestionAsker

    DTS ERROR SQL 2005

    ALL, SQL server2005 Enterprise Windows 2003 Server I'm trying to run an import on a weekly basis of an entire database, tried replication but it just wouldn't happen. The issue is most of the tables are around 200Mb, one is 10Gb as it contains blobs of XML(don't ask!). Most of the tables copy...
  4. QuestionAsker

    SQL SOS

    Hi, I have a bit of a quandry with a procedure request and was wondering if anyone out there could point me in the right direction: I have a lookup table A and 2 updateable tables B and C For every account in A that matches in table B i need to insert 2 records into table B in the following...

Part and Inventory Search

Back
Top