why I see no any data connection afer clik "new" in OLE DB connection manager step ?? help me please

Why making changes in registry

"INSERT INTO LOGS VALUES"('"+@[User::filepath]+"', "+(DT_WSTR,12)@[User::RecordCount]+",GETDATE())"

Hi Bro , Currently I'm doing ssis package migration. The old package was created 2008 version . In my server has 2022 version . When I'm opening the package it has been upgraded . But not showing dtsx file The error is : The XML element DeploymentModelSpecificContent is missing from the file named: Pls help on this

very good

I'm having an issue with extracting the Excel file name in SSIS. I've used a Foreach Loop and a Derived Column, but it always defaults to the first file instead of the desired one. What is the solution to this problem?

Thanks a lot, it reallyt well explained.

nicely explained!!! Can we import data from sap (fico) to sql server using ssis package?

I was searchig for performance tunning vedios i found this ,i am not clear abut 2&3 points (2.if we create indexes on joins columns in the update will it impact performance,3.creating a new table in place of update for huge data loads),please ellobrate more or create one more vedio to understand better

Hi Aqil, Amazing, your all video really appreciated.could you please help me on this to extract data from staging tables to partitioned tables with incremental load ?please suggest with example in SSIS. Thanks in advance.

Hi bro, do we have video on how fetch data from SAS using SSIS? If not can you tell me how to do it?

This is an excellent video. Be sure to watch the last 3.5 minutes!!! It solved my problem by creating an Execute SQL Task to the Excel Connection Manager (not the db) that creates the Sheet needed to dynamically map the columns to the dynamic Excel file.

Thanks a lot. How to create the Project Parameters that can be sourced from a config file like DBName, UserName, Passwd? And how to encrypt Passwd? In Informatica, you have a tool called pmpasswd using which we can encrypt the passwd and use it in the config file.

Thank you bro..crystal clear❤

How can I send a Stored procedure output in the email body and sent the notification

thank you, very clear !

Your all video is very helpful

Very thanks you very much

Thanks can if I need only one day data is it possible sir

Thanks a lot Sir🧑‍💻

sir my db said The job failed. Check the event log on the destination server for details. what should i do now

Hi Sir, Suppose have 6 servers, every server having 3 databases in 3 databases having one same table. from this table using 3 select queries we will get different data like activeyes,activeNo, and activetotal. this whole data needs to load into one CSV file. After this will get new server.for this server also use same machanism. Without changing in the package how to add new server configuration in Package.

Bro nice job Kudos

I HAVE "Windows 11 Home Single Language". DEVICE NAME: Laptopnum02. NO PASSWORD FOR MY ACCOUNT. 1.CREATE A TEST *.CMD FILE . CREATE A *.TXT THEN CHANGED THE EXTENSION TO: *.CMD THIS MAKES THE *.CMD CALLED: creararchivo.cmd @echo off echo Este es el contenido del archivo creado por demo.cmd. > archivo_creado.txt echo Segunda línea en el archivo creado. >> archivo_creado.txt echo Tercera línea en el archivo creado. >> archivo_creado.txt I DISABLED MY ANTIVIRUS (AVAST) CREATE CREDENTIALS IN sqldeveloper BEGIN sys.dbms_credential.create_credential( username => 'brandon tony rojas', password => '123', database_role => 'SYSDBA', windows_domain => 'laptopnum02', enabled => true, credential_name => 'CREDENCIAL_PRUEBA' ); END; CREATE JOB. I have tried both ways, entering first with CMD then directly to the executable. But apparently it doesn't open any, access denied it tells me when I try directly to the executable, without credentials. But I checked my permissions on my WINDOW account: brandon tony roja, domain = laptopnum02 and everything was fine. BEGIN DBMS_SCHEDULER.create_job ( job_name => 'PRUEBA', job_type => 'EXECUTABLE', job_action => 'C:\BackupOracle\creararchivo.cmd',--'C:\WINDOWS\SYSTEM32\CMD.EXE', --number_of_arguments => 2, start_date => SYSTIMESTAMP, repeat_interval => 'FREQ=DAILY; BYHOUR=23', enabled => FALSE, auto_drop => FALSE, comments => 'Job para realizar backup diario' ); -- EJECUTAR COMANDOS DENTRO DEL SIMBOLO DEL SISTEMA --DBMS_SCHEDULER.set_job_argument_value ('PRUEBA', 1, '/C'); --DBMS_SCHEDULER.set_job_argument_value ('PRUEBA', 2, 'C:\BackupOracle\creararchivo.cmd'); dbms_scheduler.set_attribute('PRUEBA', 'credential_name', 'CREDENCIAL_PRUEBA'); DBMS_SCHEDULER.enable('PRUEBA'); END;

For the excel connection string what value we need to set HDR= ??

Is it possible to do this without using C# or an external tool?

Hi

Hi. How to handle.. if we have got new column in the CSV file but we dont want to load that column in to the Table. currently our package getting failed when ever new column added to the CSV file. We would like to skip all those new columns and proceed with the existing columns which are mapped with destination DB columns. . COuld you pls hele me on this.

Great !!! Your video really amazing. I have one question,could you please help me to resolve. Actually want to develop a SSIS package for importing Customer where the data is provided from multiple flat file sources. The customer primary data like customer id, name from one file and address information from different file source. The customer address data also contain multiple address information for each customer. need to get the latest customer information and merge it with customer primary data and import it into destionation customer table. How to design such a logic and it must be recent customer infomation is imported ? Please explain by drawing a diagram.

Hi Aqil , could you please suggest if possible. if i have 5 flat file and each has different different data like one fact table and dimensional table and want to merge all these into one flat file , is it possible to merge.

Hi Aqil,your knowledge is really amazing and the way you are explain its really awesome.

I am getting ole db error so make the delay validation as true but still getting excel connection manager error

Hi Aqil, thank you for the informative video. What if I want to read in the last row monthly? my sheet also has IDs.

Spot on sir! Thank you!

SIr it is giving me this error when we created parameters for Ram person, Execute SQL Task: Executing the query "insert into Person values (?,?,?)" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Task failed: Execute SQL Task. Can u pls tell me the issue?

Excellent explanation as usual, thanks Aqil sir

I dont want to click OK and have string truncated.

You sir, are a lifesaver. Thankyouuu!!!

can you make one video or give me solution for below requirement, Description:- This is a request for the Implemention of the SSIS package which will serve the purpose of file processing involving the validations of the File Naming Conventions [Name+Date], File Headers and File Duplication. Package Implementation:- 1.Read the .csv file from the particular shared path and import the data into the destination database table [ModelData] Destination Table Name: ModelData Table Columns : 1.Primary Key: ModelID = IDENTITY(1,1) PRIMARY KEY 2.File Headers as Columns : ModelType ,ModelName, Brand, Company 3.Additonal Columns: 1.DateCreated [Current System Date] 2.FileName [Name of the File] 3.FileDate [Extract from File Name] 4.Record Count [Optional] [Number of Records Imported from the File] Log Table Name : ModelDataImportLog Table Columns : 1.Primary Key: LogID = IDENTITY(1,1) PRIMARY KEY 2.Other Columns:- 1.DateCreated [Current System Date] 2.FileName [Name of the File] 3.PackageName 4.Error_Message Below Validations need to in place the File Processing:=- 1.File Read: 1.Check the Source File path and look for the File Names with the naming Convention of: ImportFileForDataProcessing_YYYYMMDD.csv example: ImportFileForDataProcessing_YYYYMMDD.csv and ImportFileForDataProcessing_00230229.csv. If the File Name is not complying to the convention or the date is invalid in the name , log it to the log table with the message that File Name is invalid and move the file to the Destination Location. When Moving Append the Current TimeStamp to the File+InvalidName. Example: ImportFileForDataProcessing_YYYYMMDD_YYYYMMDD_InvalidName.csv 2.File Headers : 2.Check the File Headers in the input file .If the File headers are not compliant to the Headers , log it to the log table with the message that File Headers are incorrect and move the file to the Destination Location. When Moving Append the Current TimeStamp to the File+InvalidHeaders. Example: ImportFileForDataProcessing_YYYYMMDD_YYYYMMDD_InvalidHeaders.csv 3.Duplicate File Check: Check If the Source input File is already processed or not .If the file is already been processed earlier [Check from ModelData ] then move it to destination Location and log the details in the log table with the message that File is already processed. When Moving Append the Current TimeStamp+Duplicate to the File. Example: ImportFileForDataProcessing_YYYYMMDD_YYYYMMDD_Duplicate.csv

where can i find the code sir?

As always, Aqil - solid info. Thank-you.

for those who cant see variable to set date value dropdown Click on the 'variable to set date values' input box, and use SCROLL THE WHEEL MOUSE to change between variables.

Error code 1290

Hi Aqil, can you make some videos on SSAS

Hi, great video, i had a problem , when i click on test conection i got an error "est connection failed because of an error in initializing provider. Délai d'attente de connexion expiré" anyone can help me pls

Thanks, it was amazing. I followed the steps and it worked perfectly. Thank you 🥰

Superb, really outstanding, kindly make video on fetching data from external API.

Hey great video But can I get txt file to add these data into the database , it will help me a lot Thanks

It finally works for me :D Thank you very much for this tutorial!

Hi bro, I receive a task from where they want to load only latest date file to SQL server from FTP Server. How can we fetch only latest date file from FTP? using SSIS