User Profile

Collapse

Profile Sidebar

Collapse
chompy
chompy
Last Activity: Mar 31 '10, 12:50 AM
Joined: Mar 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chompy
    replied to Bulk Insert - Dynamic Errorfile Filename
    in SQL Server
    Thanks CK,

    This is what I ended up with.

    DECLARE @sqlstmt varchar(500),
    @errorfilename varchar(150),
    @TodayDate as varchar(40),
    @TodayHour as varchar(40),
    @TodayMinu as varchar(40)

    SELECT @TodayDate = CONVERT(varchar (10), GETDATE(), 112)
    SELECT @TodayHour = DATEPART(hh,GET DATE())
    SELECT @TodayMinu = DATEPART(mi,GET DATE())
    ...
    See more | Go to post

      Leave a comment:

    • chompy
      started a topic Bulk Insert - Dynamic Errorfile Filename
      in SQL Server

      Bulk Insert - Dynamic Errorfile Filename

      I am trying to dynamically create the errorfile name with the date the error occured. The error occurs at ERRORFILE = @errorfilename

      Is this possible?

      Here is the script I have so far...

      -------------------------------------------------------------------------------------------------------------------

      USE Temp

      GO

      DECLARE @errorfilename text

      SET...
      See more | Go to post
      No activity results to display
      Show More
      Working...