Who is online?  0 guests and 0 members
Home  »  search results

Search Results: timestamp

31 results found
  • Embedding comments or tags within report for admins?
    Decoy, You have many options here. I personally would just put the execution date and timestamp on the report. Then what you could do is have them email that the report to you. You could use that datetime timestamp to query the report execution log for th
    Author: briankmcdonald briankmcdonald     Date: 4/25/2011     Section: Forum
  • How to rename file and append timestamp using script task
    In this article you will learn how to rename file and append timestamp using script task in ssis.
    Author: NayanPatel NayanPatel     Date: 8/31/2011     Section: Article
  • Variable Expression - first day of current month
    I'm trying to set the value of a variable in SSIS to be the first day of the current month with no timestamp. I've been unable to get the expression to evaluate properly. I'm sure I'm missing something obvious but am unable to see it. My expression: DATEA
    Author: jasonr jasonr     Date: 8/8/2011     Section: Forum
    tags : datetime, variable
  • Using TimeStamp for Incremental Loads
    These are not DateTime fields, they are of data type Timestamp. My understanding is that they are unique, but that they cannot be used to determine which records have been updated after others. You can look to see if a partciular timestamp changed, but yo
    Author: DavidStein DavidStein     Date: 12/6/2010     Section: Forum
  • Do you want to rename the package object as well?
    Answering this question the wrong way can have at least one undesirable effect on your package that I know about. I was following someone else’s work and adding logging to a package and was using a system variable to append the package name to a file name
    Author: timmurphy timmurphy     Date: 11/12/2010     Section: Blog
  • Append Timestamp to Log File Name
    It is handy to be able to look at a long list of Package Log Files and find the one you are looking for by a time stamp. Here’s how to append a Timestamp to a log file using package name. In this case I have already created a txt log file connection named
    Author: timmurphy timmurphy     Date: 11/8/2010     Section: Blog
  • Dealing with time duplicates
    I know I'm "late to the party" with this reply - and you may have already found a solution to this with DustinRyan's help. But if you haven't yet - a few things come to mind when I read your post. According to http://msdn.microsoft.com/en-us/library/ms187
    Author: KeithHyer KeithHyer     Date: 7/21/2011     Section: Forum
  • Learning to use Derived Columns Transform to convert String data type to “Datetime” type
    In loading “.csv” files to a SQL Server 2008 database, I have encountered several data type issues, especially regarding “Datetime” for a “Modified Date” column on my tables. Here is my ordeal: After adding my Flat File
    Author: nube07 nube07     Date: 3/19/2012     Section: Blog
  • Appending Date to End of Report Name in Reporting Services Subscription
    Recently, a friend of mine asked me how he could have the date appended to the end of a file name when creating a standard subscription in Reporting Services. At first the requirement was straight forward as it only needed date and it would need to be sav
    Author: briankmcdonald briankmcdonald     Date: 11/9/2010     Section: Blog
  • Moving and Renaming files in SSIS
    Hi jampa. Well, there are a lot of solutions to do what you need need. Another approach is by script task as shown by Nayan . You link us to a solution. Instead of that, can you show us what kind of problems are you facing, or erros, so we can debug your
    Author: marcoadf marcoadf     Date: 1/11/2012     Section: Forum
  • Date Conversion in SSIS Derived Column
    Hi Forum, Expdate is sourced from a flatfile with string datetype and format '20090630162256' so i use the expression in SSIS Derived column to get the result as "2009-06-30 16:22:56" ( it got null values too) LEN(TRIM(expires)) == 0 ? NULL(DT_DBTIMESTAMP
    Author: jampa.sb jampa.sb     Date: 12/28/2011     Section: Forum
  • Error
    Hi Here Im mapping Policy Number(nvarchar),Inception date(DateTimestamp),ExpiryDate(DateTimestamp) these three columns to destionation Policy table Policy Number(Varchar),InceptionDate(FK,Int),ExpiryDate(Fk,Int). so,i took oledb source and destination and
    Author: veni veni     Date: 7/10/2010     Section: Forum
  • Some Statements To Return Today's Date
    Any of the following Statements will give your current Date and Time: SYSDATETIME() SYSDATETIMEOFFSET() SYSUTCDATETIME() GETDATE() GETUTCDATE(); CURRENT_TIMESTAMP
    Author: manfredtabe manfredtabe     Date: 10/25/2011     Section: Blog
  • Variable Expression - first day of current month
    Sorry about that. I assumed since you said, "with no timestamp" that you meant you wanted it without any time on the end. To convert what either Daniel or I did to a datetime, create your variable as a DateTime data type and modify the expression with a t
    Author: KeithHyer KeithHyer     Date: 8/9/2011     Section: Forum
    tags : datetime
  • Date Conversion in SSIS Derived Column
    From your example, I would say you got your expression well done. I would do tests below, in same order: Move data with conversion error to a flat file so you can debug the problem in a better way Make sure that you got only 2 available values: null or a
    Author: marcoadf marcoadf     Date: 12/28/2011     Section: Forum
  • site suggestion(s)
    I whole-heartedly agree on the comment about not having dates on any of the timestamps, so I guess I am just "second-ing" that statement...
    Author: cwe424 cwe424     Date: 4/6/2011     Section: Forum
  • Message: 'Microsoft' is undefined
    Starting today my users are getting the following when accessing SSRS reports on IE8. But it works fine on IE9. I tried Compatibility View but it didn't help? Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trid
    Author: maclean maclean     Date: 11/7/2011     Section: Forum
  • Casting Date from Strings and Numbers
    I was minding my own business when all of a sudden I ran into a Derived Column that needed to be a combination of three string columns which held YEAR, MONTH and DAY. MONTH and DAY were both 2 characters long but the YEAR column was 3 characters long. As
    Author: timmurphy timmurphy     Date: 7/7/2010     Section: Blog
  • Calculate the Date of the Previous Sunday
    There are a number of ways that you can calculate dates using T-SQL. A common practice is to find the first day of the week which can be accomplished easily by using the following function. select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) However, you will
    Author: BradSchacht BradSchacht     Date: 3/10/2010     Section: Blog
  • Have any of you used this Slowly Changing Dimension Component?
    I have used both SCD as well as kimble; if you volume od data is low then I preffer to use SCD as itf fairly simple to but but have problem with performance when used with large volume of data; however Kimble use it very efficently by doind in memmory com
    Author: pawandeep pawandeep     Date: 10/8/2010     Section: Forum
  • SCD and more
    I have used both SCD as well as kimble; if you volume od data is low then I preffer to use SCD as itf fairly simple to but but have problem with performance when used with large volume of data; however Kimble use it very efficently by doind in memmory com
    Author: pawandeep pawandeep     Date: 10/8/2010     Section: Forum
  • Dealing with time duplicates
    I was only doing the db_datetimestamp when I initially imported from a text file into the staging table. What you described is what I've been trying to do, but it isn't working - I'm getting a PK constraint error on my destination table. I was thinking th
    Author: shauntih shauntih     Date: 7/22/2011     Section: Forum
  • Dealing with time duplicates
    I have an SSIS package that inserts data into a database, but only rows that have a TempDateTime every 30 minutes in the source file. I cannot modify the source file, which records data every minute. When I pull the data, it has data that is already in th
    Author: shauntih shauntih     Date: 7/19/2011     Section: Forum
  • SSIS SFTP Task Factory problem
    I have a directory I need to get to (which I can using the SFTP Task thank goodness), but I am running into an issue. I'm grabbing Red-Gate SQL Backup log files that I have to apply to my db, but I have to apply them in order. I have an SFTP task to get t
    Author: SQLKohai SQLKohai     Date: 9/20/2011     Section: Forum
  • load flat files with names into a table
    Do you have some rules or restrictions that avoids any file without timestamp, being imported? If not, I think you can do it in derived columns, using LEFT and substring expressions to get day, month, year and time. All you need is to concatenate: LEFT(fi
    Author: marcoadf marcoadf     Date: 12/16/2011     Section: Forum