I am trying to run a sql query that will return last week’s data to the date. For example, today is Monday. I want to return last Monday’s data only. The prior week to the day. What I am doing is getting last week’s ARAging Snapshot for my company. (What the data was last Monday, compared to…
Tag: ssis
Managing security for an SSIS package accessing another SQL server – best practice
Lets suppose I have to create and deploy an SSIS package to sql server (name it SQL1) load some data from another sql server (SQL2). On SQL I want to create a job as well to execute this package. Lets suppose other untrusted persons also can create SSIS packages and jobs on this server, who are not allowed to…
OLE DB Destination: Invalid character value for cast specification
My table source: num_facture TYPE actif date 1 1 1 2010-01-31 00:00:00.000 2 2 1 2011-01-31 00:00:00.000 3 3 2 2012-01-31 00:00:00.000 4 4 2 2013-01-31 00:00:00.000 The Column data types are: Column Data Type TYPE tinyint Actif tinyint date datetime I’m working with SSIS to load my destination table. So…
Why is the SSIS variable not passing the milliseconds part into the query?
DB SETUP: SSIS: Execute SQL task: The task has an output parameter (say Param1) of data type DT_DBTIMESTAMP. The SSIS variable data type is DateTime. Then in a subsequent Data Flow Task (say TASK2), I have an OLE DB source SQL command text: The above variable is used as an input parameter. In the SQL profiler…
Using SSIS OR T-SQL Split a column of quoted & unquoted comma separated values into multiple columns
I have comma separated data in a column named C0. The data in C0 looks like this: C0 “Pacey LLC.”,213830ZZ,11/1/2017,11/1/2017,”297,311.74″,”2,371.40″,0.00,”1,325.18″,0.00,42.22,”123,986.56″ Mike The Miker,9814140VCD,12/1/2018,12/1/2018,”3,917,…
SSIS Script Task throws Object reference not set to an instance of an object
I am trying to query the database and send the content in the body of the email. When I try to run the package it throws deadlock error. Can anyone please suggest what is that I am missing Script is like below Below is the And the package looks like below.. For every user I need to get all the
SQL -Pivoting a column from a table which have Unique records
I am trying to pivot a table to Row which have duplicate records on all columns but, a unique ID Named ([log_ID]) at the last columns . I wont log_ID field pivoted and given dynamic name as log_ID_1 ,log_ID_2 …etc FYI – THE log_ID’s is not static they change at every execution’s they c…
Rewrite a sql query for better optimization [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 11 months ago. Improve this question I have a table that has the following data id orderid 1 0 1 1 1 2 2 0 3 0 3 1 An id
Finding Occurrence of the duplicate values
I have table with 3 columns (id, Name, Occurrence), I want to update the Occurrence column ,based on the id column, attached snap for the reference. for example if my id column has “606” value 3 times then my occurrent column should have 3 against all the “606” value. Below is the meth…
Use SSIS expresion to break up Full Name in to Seperate fields, Last First Middle
I have a full name field that has data in the format of Last Name First Name Middle Name some of the data doesn’t have a Middle Name where as it will be just Last Name First Name also some of the data has 2 spaces between the Last Name and First Name where as it comes to be Last